Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	1300
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	174.4 KiB
Average record size in memory	137.4 B

Variable types

Text	9
DateTime	2
Numeric	2
Boolean	1
Categorical	3
Unsupported	1

Alerts

`user_ratings` is highly overall correlated with `vader_sentiment` and 1 other fields	High correlation
`vader_sentiment` is highly overall correlated with `user_ratings` and 2 other fields	High correlation
`would_recommed_to_others` is highly overall correlated with `user_ratings` and 2 other fields	High correlation
`vader_upper_binned` is highly overall correlated with `vader_sentiment` and 1 other fields	High correlation
`reviews` has unique values	Unique
`reviews_lemm_spacy` has unique values	Unique
`vader_nnp` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2024-02-05 01:59:47.592149
Analysis finished	2024-02-05 01:59:53.821752
Duration	6.23 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

title
Text

Distinct	1278
Distinct (%)	98.3%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

Length

Max length	81
Median length	54
Mean length	30.569231
Min length	13

Characters and Unicode

Total characters	39740
Distinct characters	81
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1265 ?
Unique (%)	97.3%

Sample

1st row	“Worst service ever”
2nd row	"unprofessional attitude of the pilots"
3rd row	“Next time it will be Jet2”
4th row	“become the Ryanair of long-haul travel”
5th row	“They never help us”

Value	Count	Frequency (%)
the	184	2.9%
a	171	2.7%
was	169	2.6%
to	140	2.2%
service	129	2.0%
flight	115	1.8%
and	111	1.7%
very	101	1.6%
ba	93	1.4%
not	81	1.3%
Other values (1403)	5130	79.9%

Most occurring characters

Value	Count	Frequency (%)
	5154	13.0%
e	4061	10.2%
"	2542	6.4%
a	2452	6.2%
t	2330	5.9%
o	2210	5.6%
i	2200	5.5%
r	2162	5.4%
s	1985	5.0%
n	1953	4.9%
Other values (71)	12691	31.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	30900	77.8%
Space Separator	5155	13.0%
Other Punctuation	2654	6.7%
Uppercase Letter	806	2.0%
Decimal Number	101	0.3%
Final Punctuation	46	0.1%
Dash Punctuation	40	0.1%
Initial Punctuation	19	< 0.1%
Control	16	< 0.1%
Currency Symbol	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	4061	13.1%
a	2452	7.9%
t	2330	7.5%
o	2210	7.2%
i	2200	7.1%
r	2162	7.0%
s	1985	6.4%
n	1953	6.3%
l	1610	5.2%
d	1186	3.8%
Other values (16)	8751	28.3%

Uppercase Letter

Value	Count	Frequency (%)
A	176	21.8%
B	145	18.0%
I	93	11.5%
C	56	6.9%
T	52	6.5%
S	40	5.0%
O	27	3.3%
F	26	3.2%
W	26	3.2%
E	26	3.2%
Other values (15)	139	17.2%

Decimal Number

Value	Count	Frequency (%)
2	20	19.8%
5	17	16.8%
0	14	13.9%
7	12	11.9%
3	11	10.9%
1	10	9.9%
4	10	9.9%
6	4	4.0%
8	2	2.0%
9	1	1.0%

Other Punctuation

Value	Count	Frequency (%)
"	2542	95.8%
,	49	1.8%
'	38	1.4%
!	9	0.3%
/	7	0.3%
.	5	0.2%
%	2	0.1%
\	1	< 0.1%
;	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	5154	> 99.9%
	1	< 0.1%

Final Punctuation

Value	Count	Frequency (%)
’	28	60.9%
”	18	39.1%

Control

Value	Count	Frequency (%)
	8	50.0%
	8	50.0%

Currency Symbol

Value	Count	Frequency (%)
£	1	50.0%
€	1	50.0%

Dash Punctuation

Value	Count	Frequency (%)
-	40	100.0%

Initial Punctuation

Value	Count	Frequency (%)
“	19	100.0%

Other Number

Value	Count	Frequency (%)
½	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	31706	79.8%
Common	8034	20.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	4061	12.8%
a	2452	7.7%
t	2330	7.3%
o	2210	7.0%
i	2200	6.9%
r	2162	6.8%
s	1985	6.3%
n	1953	6.2%
l	1610	5.1%
d	1186	3.7%
Other values (41)	9557	30.1%

Common

Value	Count	Frequency (%)
	5154	64.2%
"	2542	31.6%
,	49	0.6%
-	40	0.5%
'	38	0.5%
’	28	0.3%
2	20	0.2%
“	19	0.2%
”	18	0.2%
5	17	0.2%
Other values (20)	109	1.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	39671	99.8%
Punctuation	65	0.2%
None	3	< 0.1%
Currency Symbols	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	5154	13.0%
e	4061	10.2%
"	2542	6.4%
a	2452	6.2%
t	2330	5.9%
o	2210	5.6%
i	2200	5.5%
r	2162	5.4%
s	1985	5.0%
n	1953	4.9%
Other values (64)	12622	31.8%

Punctuation

Value	Count	Frequency (%)
’	28	43.1%
“	19	29.2%
”	18	27.7%

None

Value	Count	Frequency (%)
£	1	33.3%
½	1	33.3%
	1	33.3%

Currency Symbols

Value	Count	Frequency (%)
€	1	100.0%

reviews
Text

UNIQUE

Distinct	1300
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

Length

Max length	3491
Median length	1102.5
Mean length	827.43
Min length	131

Characters and Unicode

Total characters	1075659
Distinct characters	106
Distinct categories	16 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1300 ?
Unique (%)	100.0%

Sample

1st row	Worst service ever. Lost baggage because of delayed flight and missed connection and no one is helping to get it back. British Airways website is broken so it doesn’t let me fill missing report and doesn’t give me missing file report number and so no way to contact British Airways because they have dumbest ever AI chatbot.
2nd row	BA 246 21JAN 2023 Did not appreciate the unprofessional attitude of the pilots. Flight scheduled departure 16:20. Advised boarding time 15:20. Whole flight full of passengers waiting at the gate to board at 15:20. 15:40 the cabin crew board. 15:55 the pilots board - each with a Sao Paulo Airport Duty Free branded shopping bag. 16:20 the flight is still boarding. Finally pushes back just before 17:00, 40 minutes late. Captain came on the intercom to announce the delay was due to 'traffic between the crew hotel and the airport'. Sorry Captain the whole plane saw you and your pilot colleagues board fifteen minutes after the cabin crew clutching your duty free that you and your pilot colleagues still made time to stop for.
3rd row	Not a great experience. I could not check in online as two separate parts of the BA computer system do not talk to each other. At LHR a delightful check in clerk sorted it quickly, manually! We boarded on time, but luggage loading had to be halted as the Captain spotted a technical issue and an engineer was called. By the time it was sorted we had missed our slot so took off an hour behind schedule. The flight was uneventful, but the plane had clearly seen better days, legroom was appalling and the handout of a small bottle of water and a soggy cookie made one wish for the days when flying BA meant something special. Next time it will be Jet2.
4th row	I was excited to fly BA as I'd not travelled with them long haul for over 25yrs. I've travelled to Australia on many occasions, so I've pretty much travelled with them all. Terrible was my experience. BA have become the Ryanair of long-haul travel, riding on their previous good name and reputation. We were delayed for 5hrs at the terminal, where we were offered one glass of water and then at the last minute our meal - with no additional drinks offered. The charging points were outdated and 3 out of 5 didn't work (family of five travelling). The in flight entertainment was also outdated and the movies available were poor compared to other airlines. The food was atrocious - we flew BA LHR-HongKong and return and Cathay HK-Australia return and the comparison was vast. We were offered pre meal drinks and snacks, drinks with our meal, a menu for our flights so we knew our choices, the quality of the food was vastly better with Cathay. Our luggage was lost for nearly two hours in Hong Kong and when we arrived into London, one of our bags was so badly damaged it was unusable. The only redeeming part was the crew on our return flight were amazing. Severine was an angel and helped make the journey more pleasant for my kids.
5th row	I just want to warn everyone of the worst customer service experience ever! It really looks like British Airways customer service over the phone are trained to not help you in anyway and to create more problems rather than solving them. Last week we called British Airways to make a reservation for the family. At the time we explained to the customer service representative that we wanted to make a booking and then pay with a transfer of miles from American Express. The representative told us that he could not make the reservation until the miles were in the account, and asked us to contact American Express and make the transfer so that the booking could be made. The conversation was recorded by British Airways and could be checked. We immediately called AMEX (within 30 minutes) and solicited the transfer of 500K miles. AMEX clearly stated to us whether we were sure as the transfer was not reversible. We said that it was fine since we had checked previously with British Airways. We then called British Airways immediately to make our reservation to Miami. They confirmed that the miles arrived to our account, but to our surprise they told us that there was no space (not even one seat to Miami) and that we could not use the miles. We explained the situation and how we were led to believe that we could have a flight with miles if we transferred the miles, but all this went on deaf ears. We called the German office, which was absolutely unhelpful, so we also called UK customer service which was just as unhelpful. No manager was able to open a flight for us with miles and they just kept repeating that this was not possible (even though we if we paid for the flight and got the seats and also seats were available if we would have had gold status). In the end British Airways took absolutely no responsibility for causing the problem, did not give us a solution, kept our miles and we have to pay for a trip to Miami. With this service to their customers this is a company that should not be in business. Every time we call they made us wait for over 45 minutes then they answer and put us on hold, I have 2 days of waiting and talking with British Airways for over 2 hours each day, we were on the line for over 45 minutes each time. We were told by the lady agent to hang up the phone as I was too long on the phone and she had other customers? And we are not customers? They never help us.

Value	Count	Frequency (%)
the	9821	5.0%
to	6869	3.5%
and	5923	3.0%
was	4406	2.3%
a	4303	2.2%
i	3984	2.0%
in	2673	1.4%
of	2672	1.4%
flight	2412	1.2%
on	2387	1.2%
Other values (9594)	149863	76.7%

Most occurring characters

Value	Count	Frequency (%)
	196726	18.3%
e	102075	9.5%
t	74768	7.0%
a	69482	6.5%
o	63608	5.9%
n	56706	5.3%
i	53010	4.9%
r	50086	4.7%
s	49321	4.6%
h	40593	3.8%
Other values (96)	319284	29.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	819745	76.2%
Space Separator	196770	18.3%
Uppercase Letter	28412	2.6%
Other Punctuation	20048	1.9%
Decimal Number	6793	0.6%
Dash Punctuation	1424	0.1%
Final Punctuation	786	0.1%
Close Punctuation	628	0.1%
Open Punctuation	623	0.1%
Currency Symbol	238	< 0.1%
Other values (6)	192	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	102075	12.5%
t	74768	9.1%
a	69482	8.5%
o	63608	7.8%
n	56706	6.9%
i	53010	6.5%
r	50086	6.1%
s	49321	6.0%
h	40593	5.0%
l	36075	4.4%
Other values (22)	224021	27.3%

Uppercase Letter

Value	Count	Frequency (%)
I	5011	17.6%
A	4063	14.3%
T	3146	11.1%
B	3091	10.9%
L	1397	4.9%
C	1260	4.4%
W	1172	4.1%
S	1101	3.9%
H	1044	3.7%
F	993	3.5%
Other values (16)	6134	21.6%

Other Punctuation

Value	Count	Frequency (%)
.	11890	59.3%
,	5760	28.7%
'	1070	5.3%
!	354	1.8%
"	243	1.2%
/	225	1.1%
:	157	0.8%
?	155	0.8%
&	88	0.4%
;	56	0.3%
Other values (4)	50	0.2%

Decimal Number

Value	Count	Frequency (%)
0	1335	19.7%
2	1194	17.6%
1	970	14.3%
3	770	11.3%
5	704	10.4%
7	573	8.4%
4	523	7.7%
8	300	4.4%
6	219	3.2%
9	205	3.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1395	98.0%
–	22	1.5%
—	7	0.5%

Currency Symbol

Value	Count	Frequency (%)
£	128	53.8%
$	98	41.2%
€	12	5.0%

Math Symbol

Value	Count	Frequency (%)
+	45	83.3%
>	8	14.8%
~	1	1.9%

Space Separator

Value	Count	Frequency (%)
	196726	> 99.9%
	44	< 0.1%

Final Punctuation

Value	Count	Frequency (%)
’	723	92.0%
”	63	8.0%

Close Punctuation

Value	Count	Frequency (%)
)	627	99.8%
]	1	0.2%

Open Punctuation

Value	Count	Frequency (%)
(	622	99.8%
[	1	0.2%

Initial Punctuation

Value	Count	Frequency (%)
“	64	73.6%
‘	23	26.4%

Control

Value	Count	Frequency (%)
	22	50.0%
	22	50.0%

Line Separator

Value	Count	Frequency (%)
	3	100.0%

Other Number

Value	Count	Frequency (%)
½	2	100.0%

Modifier Symbol

Value	Count	Frequency (%)
´	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	848157	78.8%
Common	227502	21.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	102075	12.0%
t	74768	8.8%
a	69482	8.2%
o	63608	7.5%
n	56706	6.7%
i	53010	6.3%
r	50086	5.9%
s	49321	5.8%
h	40593	4.8%
l	36075	4.3%
Other values (48)	252433	29.8%

Common

Value	Count	Frequency (%)
	196726	86.5%
.	11890	5.2%
,	5760	2.5%
-	1395	0.6%
0	1335	0.6%
2	1194	0.5%
'	1070	0.5%
1	970	0.4%
3	770	0.3%
’	723	0.3%
Other values (38)	5669	2.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1074538	99.9%
Punctuation	915	0.1%
None	194	< 0.1%
Currency Symbols	12	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	196726	18.3%
e	102075	9.5%
t	74768	7.0%
a	69482	6.5%
o	63608	5.9%
n	56706	5.3%
i	53010	4.9%
r	50086	4.7%
s	49321	4.6%
h	40593	3.8%
Other values (77)	318163	29.6%

Punctuation

Value	Count	Frequency (%)
’	723	79.0%
“	64	7.0%
”	63	6.9%
‘	23	2.5%
–	22	2.4%
…	10	1.1%
—	7	0.8%
	3	0.3%

None

Value	Count	Frequency (%)
£	128	66.0%
	44	22.7%
ä	6	3.1%
ü	4	2.1%
é	3	1.5%
í	3	1.5%
½	2	1.0%
´	2	1.0%
ö	1	0.5%
ã	1	0.5%

Currency Symbols

Value	Count	Frequency (%)
€	12	100.0%

published_dates
Date

Distinct	901
Distinct (%)	69.3%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

Minimum	2018-03-28 00:00:00
Maximum	2024-01-23 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

user_name
Text

Distinct	1112
Distinct (%)	85.5%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

Length

Max length	33
Median length	28
Mean length	13.369231
Min length	4

Characters and Unicode

Total characters	17380
Distinct characters	68
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1027 ?
Unique (%)	79.0%

Sample

1st row	Chirag Thummar
2nd row	D Carreno
3rd row	Simon Channon
4th row	Melissa Harris
5th row	Ivana Squassabia

Value	Count	Frequency (%)
s	65	2.3%
m	50	1.7%
a	44	1.5%
c	44	1.5%
e	43	1.5%
1	43	1.5%
r	40	1.4%
j	35	1.2%
31	34	1.2%
ellis	29	1.0%
Other values (1352)	2446	85.1%

Most occurring characters

Value	Count	Frequency (%)
	2885	16.6%
e	1710	9.8%
a	1319	7.6%
r	1110	6.4%
i	999	5.7%
n	901	5.2%
s	775	4.5%
o	706	4.1%
l	656	3.8%
t	420	2.4%
Other values (58)	5899	33.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	11439	65.8%
Space Separator	2885	16.6%
Uppercase Letter	2657	15.3%
Decimal Number	384	2.2%
Dash Punctuation	11	0.1%
Other Punctuation	4	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1710	14.9%
a	1319	11.5%
r	1110	9.7%
i	999	8.7%
n	901	7.9%
s	775	6.8%
o	706	6.2%
l	656	5.7%
t	420	3.7%
v	382	3.3%
Other values (18)	2461	21.5%

Uppercase Letter

Value	Count	Frequency (%)
M	280	10.5%
S	237	8.9%
C	189	7.1%
D	175	6.6%
A	172	6.5%
R	154	5.8%
B	151	5.7%
J	137	5.2%
G	135	5.1%
H	134	5.0%
Other values (16)	893	33.6%

Decimal Number

Value	Count	Frequency (%)
1	119	31.0%
3	78	20.3%
2	58	15.1%
4	40	10.4%
6	24	6.2%
0	18	4.7%
8	16	4.2%
5	13	3.4%
7	10	2.6%
9	8	2.1%

Other Punctuation

Value	Count	Frequency (%)
'	2	50.0%
.	2	50.0%

Space Separator

Value	Count	Frequency (%)
	2885	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	11	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14096	81.1%
Common	3284	18.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1710	12.1%
a	1319	9.4%
r	1110	7.9%
i	999	7.1%
n	901	6.4%
s	775	5.5%
o	706	5.0%
l	656	4.7%
t	420	3.0%
v	382	2.7%
Other values (44)	5118	36.3%

Common

Value	Count	Frequency (%)
	2885	87.9%
1	119	3.6%
3	78	2.4%
2	58	1.8%
4	40	1.2%
6	24	0.7%
0	18	0.5%
8	16	0.5%
5	13	0.4%
-	11	0.3%
Other values (4)	22	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17374	> 99.9%
None	6	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	2885	16.6%
e	1710	9.8%
a	1319	7.6%
r	1110	6.4%
i	999	5.7%
n	901	5.2%
s	775	4.5%
o	706	4.1%
l	656	3.8%
t	420	2.4%
Other values (56)	5893	33.9%

None

Value	Count	Frequency (%)
é	4	66.7%
ö	2	33.3%

user_location
Text

Distinct	57
Distinct (%)	4.4%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

Length

Max length	21
Median length	14
Mean length	12.222308
Min length	5

Characters and Unicode

Total characters	15889
Distinct characters	46
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18 ?
Unique (%)	1.4%

Sample

1st row	Germany
2nd row	United Kingdom
3rd row	United Kingdom
4th row	United Kingdom
5th row	Germany

Value	Count	Frequency (%)
united	952	41.3%
kingdom	739	32.0%
states	202	8.8%
australia	44	1.9%
canada	42	1.8%
germany	30	1.3%
south	22	1.0%
africa	20	0.9%
ireland	16	0.7%
switzerland	15	0.7%
Other values (58)	225	9.8%

Most occurring characters

Value	Count	Frequency (%)
n	1928	12.1%
i	1870	11.8%
d	1823	11.5%
t	1490	9.4%
e	1364	8.6%
	1007	6.3%
U	952	6.0%
o	807	5.1%
m	795	5.0%
g	781	4.9%
Other values (36)	3072	19.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	12576	79.1%
Uppercase Letter	2306	14.5%
Space Separator	1007	6.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	1928	15.3%
i	1870	14.9%
d	1823	14.5%
t	1490	11.8%
e	1364	10.8%
o	807	6.4%
m	795	6.3%
g	781	6.2%
a	701	5.6%
s	290	2.3%
Other values (14)	727	5.8%

Uppercase Letter

Value	Count	Frequency (%)
U	952	41.3%
K	754	32.7%
S	275	11.9%
A	82	3.6%
C	51	2.2%
I	41	1.8%
G	40	1.7%
N	23	1.0%
F	13	0.6%
B	12	0.5%
Other values (11)	63	2.7%

Space Separator

Value	Count	Frequency (%)
	1007	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14882	93.7%
Common	1007	6.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	1928	13.0%
i	1870	12.6%
d	1823	12.2%
t	1490	10.0%
e	1364	9.2%
U	952	6.4%
o	807	5.4%
m	795	5.3%
g	781	5.2%
K	754	5.1%
Other values (35)	2318	15.6%

Common

Value	Count	Frequency (%)
	1007	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15889	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	1928	12.1%
i	1870	11.8%
d	1823	11.5%
t	1490	9.4%
e	1364	8.6%
	1007	6.3%
U	952	6.0%
o	807	5.1%
m	795	5.0%
g	781	4.9%
Other values (36)	3072	19.3%

user_ratings
Real number (ℝ)

HIGH CORRELATION

Distinct	10
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.1746154

Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	10.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	3
Q3	7
95-th percentile	10
Maximum	10
Range	9
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.2533943
Coefficient of variation (CV)	0.77932792
Kurtosis	-1.2046091
Mean	4.1746154
Median Absolute Deviation (MAD)	2
Skewness	0.57513754
Sum	5427
Variance	10.584575
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	436	33.5%
2	154	11.8%
3	125	9.6%
10	118	9.1%
8	100	7.7%
9	93	7.2%
4	82	6.3%
7	75	5.8%
5	64	4.9%
6	53	4.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	436	33.5%
2	154	11.8%
3	125	9.6%
4	82	6.3%
5	64	4.9%
6	53	4.1%
7	75	5.8%
8	100	7.7%
9	93	7.2%
10	118	9.1%

Value	Count	Frequency (%)
10	118	9.1%
9	93	7.2%
8	100	7.7%
7	75	5.8%
6	53	4.1%
5	64	4.9%
4	82	6.3%
3	125	9.6%
2	154	11.8%
1	436	33.5%

trip_details
Text

Distinct	1297
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

Length

Max length	158
Median length	133
Mean length	112.96385
Min length	65

Characters and Unicode

Total characters	146853
Distinct characters	71
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1294 ?
Unique (%)	99.5%

Sample

1st row	Type Of TravellerSolo Leisure Seat TypeEconomy Class RouteBoston to Düsseldorf via London Date FlownJanuary 2024
2nd row	AircraftA350 Type Of TravellerBusiness Seat TypeEconomy Class RouteSao Paulo to London Heathrow Date FlownJanuary 2024
3rd row	AircraftA320 Type Of TravellerCouple Leisure Seat TypeEconomy Class RouteLondon Heathrow to Lisbon Date FlownJanuary 2024
4th row	Type Of TravellerFamily Leisure Seat TypeEconomy Class RouteLondon to Hong Kong Date FlownJanuary 2024
5th row	Type Of TravellerFamily Leisure Seat TypeBusiness Class RouteDusseldorf (DUS) to Miami (MIA) Date FlownJanuary 2024

Value	Count	Frequency (%)
date	1300	6.9%
seat	1300	6.9%
of	1298	6.9%
type	1298	6.9%
to	1296	6.8%
class	1187	6.3%
leisure	1043	5.5%
typeeconomy	724	3.8%
london	619	3.3%
routelondon	485	2.6%
Other values (522)	8377	44.3%

Most occurring characters

Value	Count	Frequency (%)
e	15310	10.4%
	13075	8.9%
o	10811	7.4%
a	8583	5.8%
r	7292	5.0%
t	7155	4.9%
l	6850	4.7%
n	6598	4.5%
s	6198	4.2%
	4635	3.2%
Other values (61)	60346	41.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	99157	67.5%
Uppercase Letter	21693	14.8%
Space Separator	13075	8.9%
Decimal Number	8039	5.5%
Control	4635	3.2%
Dash Punctuation	192	0.1%
Other Punctuation	54	< 0.1%
Open Punctuation	4	< 0.1%
Close Punctuation	4	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	15310	15.4%
o	10811	10.9%
a	8583	8.7%
r	7292	7.4%
t	7155	7.2%
l	6850	6.9%
n	6598	6.7%
s	6198	6.3%
u	4591	4.6%
i	4347	4.4%
Other values (18)	21422	21.6%

Uppercase Letter

Value	Count	Frequency (%)
T	4004	18.5%
L	2268	10.5%
S	1991	9.2%
C	1774	8.2%
F	1700	7.8%
D	1553	7.2%
A	1517	7.0%
O	1438	6.6%
R	1337	6.2%
B	1193	5.5%
Other values (16)	2918	13.5%

Decimal Number

Value	Count	Frequency (%)
2	2537	31.6%
0	2004	24.9%
7	901	11.2%
1	826	10.3%
3	717	8.9%
8	464	5.8%
9	420	5.2%
4	141	1.8%
5	24	0.3%
6	5	0.1%

Other Punctuation

Value	Count	Frequency (%)
/	46	85.2%
,	8	14.8%

Space Separator

Value	Count	Frequency (%)
	13075	100.0%

Control

Value	Count	Frequency (%)
	4635	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	192	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	4	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	120850	82.3%
Common	26003	17.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	15310	12.7%
o	10811	8.9%
a	8583	7.1%
r	7292	6.0%
t	7155	5.9%
l	6850	5.7%
n	6598	5.5%
s	6198	5.1%
u	4591	3.8%
i	4347	3.6%
Other values (44)	43115	35.7%

Common

Value	Count	Frequency (%)
	13075	50.3%
	4635	17.8%
2	2537	9.8%
0	2004	7.7%
7	901	3.5%
1	826	3.2%
3	717	2.8%
8	464	1.8%
9	420	1.6%
-	192	0.7%
Other values (7)	232	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	146846	> 99.9%
None	7	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	15310	10.4%
	13075	8.9%
o	10811	7.4%
a	8583	5.8%
r	7292	5.0%
t	7155	4.9%
l	6850	4.7%
n	6598	4.5%
s	6198	4.2%
	4635	3.2%
Other values (57)	60339	41.1%

None

Value	Count	Frequency (%)
ü	3	42.9%
ã	2	28.6%
İ	1	14.3%
é	1	14.3%

would_recommed_to_others
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.4 KiB

False	867
True	433

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	867	66.7%
True	433	33.3%

reviews_lemm_spacy
Text

UNIQUE

Distinct	1300
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

Length

Max length	2126
Median length	675
Mean length	447.71615
Min length	58

Characters and Unicode

Total characters	582031
Distinct characters	44
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1300 ?
Unique (%)	100.0%

Sample

1st row	bad service lose baggage delay flight miss connection help british airways website break let fill missing report missing file report number way contact british airway dumb ai chatbot
2nd row	ba 246 21jan 2023 appreciate unprofessional attitude pilot flight schedule departure 1620 advise boarding time 1520 flight passenger wait gate board 1520 1540 cabin crew board 1555 pilot board sao paulo airport duty free brand shopping bag 1620 flight boarding finally push 1700 40 minute late captain come intercom announce delay traffic crew hotel airport sorry captain plane pilot colleague board minute cabin crew clutch duty free pilot colleague time stop
3rd row	great experience check online separate ba computer system talk lhr delightful check clerk sort quickly manually board time luggage loading halt captain spot technical issue engineer time sort miss slot hour schedule flight uneventful plane clearly day legroom appalling handout small bottle water soggy cookie wish day fly ba mean special time jet2
4th row	excited fly ba d travel long haul 25yr ve travel australia occasion ve pretty travel terrible experience ba ryanair longhaul travel riding previous good reputation delay 5hrs terminal offer glass water minute meal additional drink offer charge point outdate 3 5 work family travel flight entertainment outdate movie available poor compare airline food atrocious fly ba lhrhongkong return cathay hkaustralia return comparison vast offer pre meal drink snack drink meal menu flight know choice quality food vastly cathay luggage lose nearly hour hong kong arrive london bag badly damage unusable redeem crew return flight amazing severine angel help journey pleasant kid
5th row	want warn bad customer service experience look like british airways customer service phone train help create problem solve week british airway reservation family time explain customer service representative want booking pay transfer mile american express representative tell reservation mile account ask contact american express transfer booking conversation record british airways check immediately amex 30 minute solicit transfer 500k mile amex clearly state sure transfer reversible fine check previously british airways british airway immediately reservation miami confirm mile arrive account surprise tell space seat miami use mile explain situation lead believe flight mile transfer mile deaf ear german office absolutely unhelpful uk customer service unhelpful manager able open flight mile repeat possible pay flight seat seat available gold status end british airways absolutely responsibility cause problem solution mile pay trip miami service customer company business time wait 45 minute answer hold 2 day wait talk british airway 2 hour day line 45 minute time tell lady agent hang phone long phone customer customer help

Value	Count	Frequency (%)
flight	2777	3.2%
ba	1505	1.7%
seat	1313	1.5%
service	1006	1.1%
time	792	0.9%
london	791	0.9%
hour	710	0.8%
good	686	0.8%
fly	648	0.7%
crew	645	0.7%
Other values (7023)	76710	87.6%

Most occurring characters

Value	Count	Frequency (%)
	86283	14.8%
e	60025	10.3%
a	42511	7.3%
r	35885	6.2%
i	35431	6.1%
t	34428	5.9%
o	31920	5.5%
n	30481	5.2%
l	30225	5.2%
s	26421	4.5%
Other values (34)	168421	28.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	488953	84.0%
Space Separator	86283	14.8%
Decimal Number	6793	1.2%
Other Number	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	60025	12.3%
a	42511	8.7%
r	35885	7.3%
i	35431	7.2%
t	34428	7.0%
o	31920	6.5%
n	30481	6.2%
l	30225	6.2%
s	26421	5.4%
c	21739	4.4%
Other values (22)	139887	28.6%

Decimal Number

Value	Count	Frequency (%)
0	1335	19.7%
2	1194	17.6%
1	970	14.3%
3	770	11.3%
5	704	10.4%
7	573	8.4%
4	523	7.7%
8	300	4.4%
6	219	3.2%
9	205	3.0%

Space Separator

Value	Count	Frequency (%)
	86283	100.0%

Other Number

Value	Count	Frequency (%)
½	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	488953	84.0%
Common	93078	16.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	60025	12.3%
a	42511	8.7%
r	35885	7.3%
i	35431	7.2%
t	34428	7.0%
o	31920	6.5%
n	30481	6.2%
l	30225	6.2%
s	26421	5.4%
c	21739	4.4%
Other values (22)	139887	28.6%

Common

Value	Count	Frequency (%)
	86283	92.7%
0	1335	1.4%
2	1194	1.3%
1	970	1.0%
3	770	0.8%
5	704	0.8%
7	573	0.6%
4	523	0.6%
8	300	0.3%
6	219	0.2%
Other values (2)	207	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	582011	> 99.9%
None	20	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	86283	14.8%
e	60025	10.3%
a	42511	7.3%
r	35885	6.2%
i	35431	6.1%
t	34428	5.9%
o	31920	5.5%
n	30481	5.2%
l	30225	5.2%
s	26421	4.5%
Other values (27)	168401	28.9%

None

Value	Count	Frequency (%)
ä	6	30.0%
ü	4	20.0%
é	3	15.0%
í	3	15.0%
½	2	10.0%
ö	1	5.0%
ã	1	5.0%

title_lemm_spacy
Text

Distinct	1181
Distinct (%)	90.8%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

Length

Max length	56
Median length	38
Mean length	18.787692
Min length	0

Characters and Unicode

Total characters	24424
Distinct characters	38
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1111 ?
Unique (%)	85.5%

Sample

1st row	bad service
2nd row	unprofessional attitude pilot
3rd row	time jet2
4th row	ryanair longhaul travel
5th row	help

Value	Count	Frequency (%)
service	133	3.7%
flight	127	3.5%
ba	94	2.6%
crew	74	2.0%
experience	71	2.0%
good	66	1.8%
seat	65	1.8%
airline	57	1.6%
bad	52	1.4%
customer	49	1.4%
Other values (1000)	2827	78.2%

Most occurring characters

Value	Count	Frequency (%)
e	2940	12.0%
	2319	9.5%
a	1797	7.4%
i	1712	7.0%
r	1666	6.8%
t	1369	5.6%
o	1367	5.6%
l	1350	5.5%
n	1233	5.0%
s	1201	4.9%
Other values (28)	7470	30.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	22003	90.1%
Space Separator	2319	9.5%
Decimal Number	101	0.4%
Other Number	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2940	13.4%
a	1797	8.2%
i	1712	7.8%
r	1666	7.6%
t	1369	6.2%
o	1367	6.2%
l	1350	6.1%
n	1233	5.6%
s	1201	5.5%
c	1152	5.2%
Other values (16)	6216	28.3%

Decimal Number

Value	Count	Frequency (%)
2	20	19.8%
5	17	16.8%
0	14	13.9%
7	12	11.9%
3	11	10.9%
1	10	9.9%
4	10	9.9%
6	4	4.0%
8	2	2.0%
9	1	1.0%

Space Separator

Value	Count	Frequency (%)
	2319	100.0%

Other Number

Value	Count	Frequency (%)
½	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	22003	90.1%
Common	2421	9.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2940	13.4%
a	1797	8.2%
i	1712	7.8%
r	1666	7.6%
t	1369	6.2%
o	1367	6.2%
l	1350	6.1%
n	1233	5.6%
s	1201	5.5%
c	1152	5.2%
Other values (16)	6216	28.3%

Common

Value	Count	Frequency (%)
	2319	95.8%
2	20	0.8%
5	17	0.7%
0	14	0.6%
7	12	0.5%
3	11	0.5%
1	10	0.4%
4	10	0.4%
6	4	0.2%
8	2	0.1%
Other values (2)	2	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24423	> 99.9%
None	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	2940	12.0%
	2319	9.5%
a	1797	7.4%
i	1712	7.0%
r	1666	6.8%
t	1369	5.6%
o	1367	5.6%
l	1350	5.5%
n	1233	5.0%
s	1201	4.9%
Other values (27)	7469	30.6%

None

Value	Count	Frequency (%)
½	1	100.0%

aircraft
Text

Distinct	110
Distinct (%)	8.5%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

Length

Max length	25
Median length	24
Mean length	6.1069231
Min length	3

Characters and Unicode

Total characters	7939
Distinct characters	40
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	72 ?
Unique (%)	5.5%

Sample

1st row	unk
2nd row	A350
3rd row	A320
4th row	unk
5th row	unk

Value	Count	Frequency (%)
unk	560	31.9%
boeing	343	19.5%
a320	185	10.5%
777	103	5.9%
a380	75	4.3%
a321	49	2.8%
777-200	48	2.7%
787	42	2.4%
747-400	41	2.3%
747	38	2.2%
Other values (59)	272	15.5%

Most occurring characters

Value	Count	Frequency (%)
n	936	11.8%
7	897	11.3%
0	610	7.7%
u	562	7.1%
k	560	7.1%
	457	5.8%
3	449	5.7%
A	418	5.3%
e	388	4.9%
o	376	4.7%
Other values (30)	2286	28.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3590	45.2%
Decimal Number	2839	35.8%
Uppercase Letter	819	10.3%
Space Separator	457	5.8%
Dash Punctuation	188	2.4%
Other Punctuation	44	0.6%
Open Punctuation	1	< 0.1%
Close Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	936	26.1%
u	562	15.7%
k	560	15.6%
e	388	10.8%
o	376	10.5%
i	353	9.8%
g	346	9.6%
r	25	0.7%
a	15	0.4%
m	10	0.3%
Other values (5)	19	0.5%

Decimal Number

Value	Count	Frequency (%)
7	897	31.6%
0	610	21.5%
3	449	15.8%
2	338	11.9%
8	186	6.6%
4	131	4.6%
1	115	4.1%
9	84	3.0%
5	24	0.8%
6	5	0.2%

Uppercase Letter

Value	Count	Frequency (%)
A	418	51.0%
B	355	43.3%
E	21	2.6%
N	10	1.2%
R	9	1.1%
D	2	0.2%
O	2	0.2%
F	1	0.1%
M	1	0.1%

Other Punctuation

Value	Count	Frequency (%)
/	39	88.6%
,	5	11.4%

Space Separator

Value	Count	Frequency (%)
	457	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	188	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4409	55.5%
Common	3530	44.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	936	21.2%
u	562	12.7%
k	560	12.7%
A	418	9.5%
e	388	8.8%
o	376	8.5%
B	355	8.1%
i	353	8.0%
g	346	7.8%
r	25	0.6%
Other values (14)	90	2.0%

Common

Value	Count	Frequency (%)
7	897	25.4%
0	610	17.3%
	457	12.9%
3	449	12.7%
2	338	9.6%
-	188	5.3%
8	186	5.3%
4	131	3.7%
1	115	3.3%
9	84	2.4%
Other values (6)	75	2.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7939	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	936	11.8%
7	897	11.3%
0	610	7.7%
u	562	7.1%
k	560	7.1%
	457	5.8%
3	449	5.7%
A	418	5.3%
e	388	4.9%
o	376	4.7%
Other values (30)	2286	28.8%

travel_type
Categorical

Distinct	5
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

Couple Leisure	433
Solo Leisure	410
Business	255
Family Leisure	200
unk	2

Length

Max length	14
Median length	12
Mean length	12.175385
Min length	3

Characters and Unicode

Total characters	15828
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Solo Leisure
2nd row	Business
3rd row	Couple Leisure
4th row	Family Leisure
5th row	Family Leisure

Common Values

Value	Count	Frequency (%)
Couple Leisure	433	33.3%
Solo Leisure	410	31.5%
Business	255	19.6%
Family Leisure	200	15.4%
unk	2	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
leisure	1043	44.5%
couple	433	18.5%
solo	410	17.5%
business	255	10.9%
family	200	8.5%
unk	2	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	2774	17.5%
s	1808	11.4%
u	1733	10.9%
i	1498	9.5%
o	1253	7.9%
r	1043	6.6%
l	1043	6.6%
	1043	6.6%
L	1043	6.6%
C	433	2.7%
Other values (9)	2157	13.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	12444	78.6%
Uppercase Letter	2341	14.8%
Space Separator	1043	6.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2774	22.3%
s	1808	14.5%
u	1733	13.9%
i	1498	12.0%
o	1253	10.1%
r	1043	8.4%
l	1043	8.4%
p	433	3.5%
n	257	2.1%
a	200	1.6%
Other values (3)	402	3.2%

Uppercase Letter

Value	Count	Frequency (%)
L	1043	44.6%
C	433	18.5%
S	410	17.5%
B	255	10.9%
F	200	8.5%

Space Separator

Value	Count	Frequency (%)
	1043	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14785	93.4%
Common	1043	6.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2774	18.8%
s	1808	12.2%
u	1733	11.7%
i	1498	10.1%
o	1253	8.5%
r	1043	7.1%
l	1043	7.1%
L	1043	7.1%
C	433	2.9%
p	433	2.9%
Other values (8)	1724	11.7%

Common

Value	Count	Frequency (%)
	1043	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15828	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	2774	17.5%
s	1808	11.4%
u	1733	10.9%
i	1498	9.5%
o	1253	7.9%
r	1043	6.6%
l	1043	6.6%
	1043	6.6%
L	1043	6.6%
C	433	2.7%
Other values (9)	2157	13.6%

seat
Categorical

Distinct	4
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

Economy Class	724
Business Class	418
Premium Economy	113
First Class	45

Length

Max length	15
Median length	13
Mean length	13.426154
Min length	11

Characters and Unicode

Total characters	17454
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Economy Class
2nd row	Economy Class
3rd row	Economy Class
4th row	Economy Class
5th row	Business Class

Common Values

Value	Count	Frequency (%)
Economy Class	724	55.7%
Business Class	418	32.2%
Premium Economy	113	8.7%
First Class	45	3.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
class	1187	45.7%
economy	837	32.2%
business	418	16.1%
premium	113	4.3%
first	45	1.7%

Most occurring characters

Value	Count	Frequency (%)
s	3673	21.0%
o	1674	9.6%
	1300	7.4%
n	1255	7.2%
a	1187	6.8%
C	1187	6.8%
l	1187	6.8%
m	1063	6.1%
c	837	4.8%
E	837	4.8%
Other values (9)	3254	18.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	13554	77.7%
Uppercase Letter	2600	14.9%
Space Separator	1300	7.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	3673	27.1%
o	1674	12.4%
n	1255	9.3%
a	1187	8.8%
l	1187	8.8%
m	1063	7.8%
c	837	6.2%
y	837	6.2%
i	576	4.2%
u	531	3.9%
Other values (3)	734	5.4%

Uppercase Letter

Value	Count	Frequency (%)
C	1187	45.7%
E	837	32.2%
B	418	16.1%
P	113	4.3%
F	45	1.7%

Space Separator

Value	Count	Frequency (%)
	1300	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	16154	92.6%
Common	1300	7.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	3673	22.7%
o	1674	10.4%
n	1255	7.8%
a	1187	7.3%
C	1187	7.3%
l	1187	7.3%
m	1063	6.6%
c	837	5.2%
E	837	5.2%
y	837	5.2%
Other values (8)	2417	15.0%

Common

Value	Count	Frequency (%)
	1300	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17454	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	3673	21.0%
o	1674	9.6%
	1300	7.4%
n	1255	7.2%
a	1187	6.8%
C	1187	6.8%
l	1187	6.8%
m	1063	6.1%
c	837	4.8%
E	837	4.8%
Other values (9)	3254	18.6%

route
Text

Distinct	824
Distinct (%)	63.4%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

Length

Max length	46
Median length	41
Mean length	22.403846
Min length	3

Characters and Unicode

Total characters	29125
Distinct characters	60
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	614 ?
Unique (%)	47.2%

Sample

1st row	Boston to Düsseldorf via London
2nd row	Sao Paulo to London Heathrow
3rd row	London Heathrow to Lisbon
4th row	London to Hong Kong
5th row	Dusseldorf (DUS) to Miami (MIA)

Value	Count	Frequency (%)
to	1296	25.9%
london	1104	22.1%
heathrow	305	6.1%
via	237	4.7%
gatwick	121	2.4%
new	48	1.0%
york	45	0.9%
johannesburg	43	0.9%
singapore	40	0.8%
los	39	0.8%
Other values (274)	1718	34.4%

Most occurring characters

Value	Count	Frequency (%)
o	4684	16.1%
	3779	13.0%
n	3192	11.0%
t	2153	7.4%
a	2034	7.0%
d	1353	4.6%
e	1309	4.5%
L	1225	4.2%
i	1076	3.7%
r	1061	3.6%
Other values (50)	7259	24.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	21824	74.9%
Space Separator	3779	13.0%
Uppercase Letter	3502	12.0%
Other Punctuation	10	< 0.1%
Dash Punctuation	4	< 0.1%
Open Punctuation	3	< 0.1%
Close Punctuation	3	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	4684	21.5%
n	3192	14.6%
t	2153	9.9%
a	2034	9.3%
d	1353	6.2%
e	1309	6.0%
i	1076	4.9%
r	1061	4.9%
s	622	2.9%
h	613	2.8%
Other values (18)	3727	17.1%

Uppercase Letter

Value	Count	Frequency (%)
L	1225	35.0%
H	353	10.1%
M	201	5.7%
G	188	5.4%
S	175	5.0%
B	165	4.7%
A	162	4.6%
C	154	4.4%
D	130	3.7%
T	108	3.1%
Other values (16)	641	18.3%

Other Punctuation

Value	Count	Frequency (%)
/	7	70.0%
,	3	30.0%

Space Separator

Value	Count	Frequency (%)
	3779	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	3	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	25326	87.0%
Common	3799	13.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	4684	18.5%
n	3192	12.6%
t	2153	8.5%
a	2034	8.0%
d	1353	5.3%
e	1309	5.2%
L	1225	4.8%
i	1076	4.2%
r	1061	4.2%
s	622	2.5%
Other values (44)	6617	26.1%

Common

Value	Count	Frequency (%)
	3779	99.5%
/	7	0.2%
-	4	0.1%
(	3	0.1%
)	3	0.1%
,	3	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	29118	> 99.9%
None	7	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	4684	16.1%
	3779	13.0%
n	3192	11.0%
t	2153	7.4%
a	2034	7.0%
d	1353	4.6%
e	1309	4.5%
L	1225	4.2%
i	1076	3.7%
r	1061	3.6%
Other values (46)	7252	24.9%

None

Value	Count	Frequency (%)
ü	3	42.9%
ã	2	28.6%
İ	1	14.3%
é	1	14.3%

date_flown
Date

Distinct	74
Distinct (%)	5.7%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

Minimum	2017-08-01 00:00:00
Maximum	2024-01-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

vader_sentiment
Real number (ℝ)

HIGH CORRELATION

Distinct	1123
Distinct (%)	86.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.040309462

Minimum	-0.9975
Maximum	0.9992
Zeros	6
Zeros (%)	0.5%
Negative	642
Negative (%)	49.4%
Memory size	10.3 KiB

Quantile statistics

Minimum	-0.9975
5-th percentile	-0.956
Q1	-0.78945
median	0.0186
Q3	0.902425
95-th percentile	0.988505
Maximum	0.9992
Range	1.9967
Interquartile range (IQR)	1.691875

Descriptive statistics

Standard deviation	0.78579572
Coefficient of variation (CV)	19.494076
Kurtosis	-1.7485178
Mean	0.040309462
Median Absolute Deviation (MAD)	0.8472
Skewness	-0.012072807
Sum	52.4023
Variance	0.61747491
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6	0.5%
-0.0516	5	0.4%
-0.7717	5	0.4%
0.9953	4	0.3%
-0.8957	4	0.3%
0.4404	4	0.3%
-0.4215	3	0.2%
0.9827	3	0.2%
0.9628	3	0.2%
0.9744	3	0.2%
Other values (1113)	1260	96.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.9975	1	0.1%
-0.9961	1	0.1%
-0.9944	1	0.1%
-0.9925	1	0.1%
-0.9905	1	0.1%
-0.9885	1	0.1%
-0.9883	1	0.1%
-0.988	1	0.1%
-0.9872	1	0.1%
-0.9853	1	0.1%

Value	Count	Frequency (%)
0.9992	2	0.2%
0.9978	2	0.2%
0.9977	1	0.1%
0.9976	1	0.1%
0.9966	1	0.1%
0.9965	1	0.1%
0.9961	1	0.1%
0.9959	1	0.1%
0.9958	1	0.1%
0.9953	4	0.3%

vader_nnp
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

vader_upper_binned
Categorical

HIGH CORRELATION

Distinct	8
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.8 KiB

0.75	449
-1.0	373
-0.75	130
0.5	93
-0.5	87
Other values (3)	168

Length

Max length	5
Median length	4
Mean length	4.04
Min length	3

Characters and Unicode

Total characters	5252
Distinct characters	7
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	-1.0
2nd row	0.5
3rd row	0.75
4th row	0.25
5th row	-1.0

Common Values

Value	Count	Frequency (%)
0.75	449	34.5%
-1.0	373	28.7%
-0.75	130	10.0%
0.5	93	7.2%
-0.5	87	6.7%
0.25	67	5.2%
-0.25	58	4.5%
0.0	43	3.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.75	579	44.5%
1.0	373	28.7%
0.5	180	13.8%
0.25	125	9.6%
0.0	43	3.3%

Most occurring characters

Value	Count	Frequency (%)
0	1343	25.6%
.	1300	24.8%
5	884	16.8%
-	648	12.3%
7	579	11.0%
1	373	7.1%
2	125	2.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3304	62.9%
Other Punctuation	1300	24.8%
Dash Punctuation	648	12.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1343	40.6%
5	884	26.8%
7	579	17.5%
1	373	11.3%
2	125	3.8%

Other Punctuation

Value	Count	Frequency (%)
.	1300	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	648	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5252	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1343	25.6%
.	1300	24.8%
5	884	16.8%
-	648	12.3%
7	579	11.0%
1	373	7.1%
2	125	2.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5252	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1343	25.6%
.	1300	24.8%
5	884	16.8%
-	648	12.3%
7	579	11.0%
1	373	7.1%
2	125	2.4%

user_ratings
vader_sentiment

vader_sentiment
user_ratings

vader_sentiment
user_ratings

Auto

Heatmap
Table

	user_ratings	vader_sentiment	would_recommed_to_others	travel_type	seat	vader_upper_binned
user_ratings	1.000	0.695	0.920	0.080	0.137	0.283
vader_sentiment	0.695	1.000	0.696	0.067	0.080	0.845
would_recommed_to_others	0.920	0.696	1.000	0.143	0.132	0.695
travel_type	0.080	0.067	0.143	1.000	0.128	0.050
seat	0.137	0.080	0.132	0.128	1.000	0.078
vader_upper_binned	0.283	0.845	0.695	0.050	0.078	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	title	reviews	published_dates	user_name	user_location	user_ratings	trip_details	would_recommed_to_others	reviews_lemm_spacy	title_lemm_spacy	aircraft	travel_type	seat	route	date_flown	vader_sentiment	vader_nnp	vader_upper_binned
0	“Worst service ever”	Worst service ever. Lost baggage because of delayed flight and missed connection and no one is helping to get it back. British Airways website is broken so it doesn’t let me fill missing report and doesn’t give me missing file report number and so no way to contact British Airways because they have dumbest ever AI chatbot.	2024-01-23	Chirag Thummar	Germany	1	Type Of TravellerSolo Leisure\nSeat TypeEconomy Class\nRouteBoston to Düsseldorf via London\nDate FlownJanuary 2024	n	bad service lose baggage delay flight miss connection help british airways website break let fill missing report missing file report number way contact british airway dumb ai chatbot	bad service	unk	Solo Leisure	Economy Class	Boston to Düsseldorf via London	January 2024	-0.966	(0.349, 0.604, 0.047)	-1.000
1	"unprofessional attitude of the pilots"	BA 246 21JAN 2023 Did not appreciate the unprofessional attitude of the pilots. Flight scheduled departure 16:20. Advised boarding time 15:20. Whole flight full of passengers waiting at the gate to board at 15:20. 15:40 the cabin crew board. 15:55 the pilots board - each with a Sao Paulo Airport Duty Free branded shopping bag. 16:20 the flight is still boarding. Finally pushes back just before 17:00, 40 minutes late. Captain came on the intercom to announce the delay was due to 'traffic between the crew hotel and the airport'. Sorry Captain the whole plane saw you and your pilot colleagues board fifteen minutes after the cabin crew clutching your duty free that you and your pilot colleagues still made time to stop for.	2024-01-21	D Carreno	United Kingdom	6	AircraftA350\nType Of TravellerBusiness\nSeat TypeEconomy Class\nRouteSao Paulo to London Heathrow\nDate FlownJanuary 2024	n	ba 246 21jan 2023 appreciate unprofessional attitude pilot flight schedule departure 1620 advise boarding time 1520 flight passenger wait gate board 1520 1540 cabin crew board 1555 pilot board sao paulo airport duty free brand shopping bag 1620 flight boarding finally push 1700 40 minute late captain come intercom announce delay traffic crew hotel airport sorry captain plane pilot colleague board minute cabin crew clutch duty free pilot colleague time stop	unprofessional attitude pilot	A350	Business	Economy Class	Sao Paulo to London Heathrow	January 2024	0.501	(0.06, 0.871, 0.069)	0.500
2	“Next time it will be Jet2”	Not a great experience. I could not check in online as two separate parts of the BA computer system do not talk to each other. At LHR a delightful check in clerk sorted it quickly, manually! We boarded on time, but luggage loading had to be halted as the Captain spotted a technical issue and an engineer was called. By the time it was sorted we had missed our slot so took off an hour behind schedule. The flight was uneventful, but the plane had clearly seen better days, legroom was appalling and the handout of a small bottle of water and a soggy cookie made one wish for the days when flying BA meant something special. Next time it will be Jet2.	2024-01-18	Simon Channon	United Kingdom	3	AircraftA320\nType Of TravellerCouple Leisure\nSeat TypeEconomy Class\nRouteLondon Heathrow to Lisbon\nDate FlownJanuary 2024	n	great experience check online separate ba computer system talk lhr delightful check clerk sort quickly manually board time luggage loading halt captain spot technical issue engineer time sort miss slot hour schedule flight uneventful plane clearly day legroom appalling handout small bottle water soggy cookie wish day fly ba mean special time jet2	time jet2	A320	Couple Leisure	Economy Class	London Heathrow to Lisbon	January 2024	0.875	(0.058, 0.819, 0.122)	0.750
3	“become the Ryanair of long-haul travel”	I was excited to fly BA as I'd not travelled with them long haul for over 25yrs. I've travelled to Australia on many occasions, so I've pretty much travelled with them all. Terrible was my experience. BA have become the Ryanair of long-haul travel, riding on their previous good name and reputation. We were delayed for 5hrs at the terminal, where we were offered one glass of water and then at the last minute our meal - with no additional drinks offered. The charging points were outdated and 3 out of 5 didn't work (family of five travelling). The in flight entertainment was also outdated and the movies available were poor compared to other airlines. The food was atrocious - we flew BA LHR-HongKong and return and Cathay HK-Australia return and the comparison was vast. We were offered pre meal drinks and snacks, drinks with our meal, a menu for our flights so we knew our choices, the quality of the food was vastly better with Cathay. Our luggage was lost for nearly two hours in Hong Kong and when we arrived into London, one of our bags was so badly damaged it was unusable. The only redeeming part was the crew on our return flight were amazing. Severine was an angel and helped make the journey more pleasant for my kids.	2024-01-18	Melissa Harris	United Kingdom	2	Type Of TravellerFamily Leisure\nSeat TypeEconomy Class\nRouteLondon to Hong Kong \nDate FlownJanuary 2024	n	excited fly ba d travel long haul 25yr ve travel australia occasion ve pretty travel terrible experience ba ryanair longhaul travel riding previous good reputation delay 5hrs terminal offer glass water minute meal additional drink offer charge point outdate 3 5 work family travel flight entertainment outdate movie available poor compare airline food atrocious fly ba lhrhongkong return cathay hkaustralia return comparison vast offer pre meal drink snack drink meal menu flight know choice quality food vastly cathay luggage lose nearly hour hong kong arrive london bag badly damage unusable redeem crew return flight amazing severine angel help journey pleasant kid	ryanair longhaul travel	unk	Family Leisure	Economy Class	London to Hong Kong	January 2024	0.477	(0.079, 0.833, 0.088)	0.250
4	“They never help us”	I just want to warn everyone of the worst customer service experience ever! It really looks like British Airways customer service over the phone are trained to not help you in anyway and to create more problems rather than solving them. Last week we called British Airways to make a reservation for the family. At the time we explained to the customer service representative that we wanted to make a booking and then pay with a transfer of miles from American Express. The representative told us that he could not make the reservation until the miles were in the account, and asked us to contact American Express and make the transfer so that the booking could be made. The conversation was recorded by British Airways and could be checked. We immediately called AMEX (within 30 minutes) and solicited the transfer of 500K miles. AMEX clearly stated to us whether we were sure as the transfer was not reversible. We said that it was fine since we had checked previously with British Airways. We then called British Airways immediately to make our reservation to Miami. They confirmed that the miles arrived to our account, but to our surprise they told us that there was no space (not even one seat to Miami) and that we could not use the miles. We explained the situation and how we were led to believe that we could have a flight with miles if we transferred the miles, but all this went on deaf ears. We called the German office, which was absolutely unhelpful, so we also called UK customer service which was just as unhelpful. No manager was able to open a flight for us with miles and they just kept repeating that this was not possible (even though we if we paid for the flight and got the seats and also seats were available if we would have had gold status). In the end British Airways took absolutely no responsibility for causing the problem, did not give us a solution, kept our miles and we have to pay for a trip to Miami. With this service to their customers this is a company that should not be in business. Every time we call they made us wait for over 45 minutes then they answer and put us on hold, I have 2 days of waiting and talking with British Airways for over 2 hours each day, we were on the line for over 45 minutes each time. We were told by the lady agent to hang up the phone as I was too long on the phone and she had other customers? And we are not customers? They never help us.	2024-01-17	Ivana Squassabia	Germany	1	Type Of TravellerFamily Leisure\nSeat TypeBusiness Class\nRouteDusseldorf (DUS) to Miami (MIA) \nDate FlownJanuary 2024	n	want warn bad customer service experience look like british airways customer service phone train help create problem solve week british airway reservation family time explain customer service representative want booking pay transfer mile american express representative tell reservation mile account ask contact american express transfer booking conversation record british airways check immediately amex 30 minute solicit transfer 500k mile amex clearly state sure transfer reversible fine check previously british airways british airway immediately reservation miami confirm mile arrive account surprise tell space seat miami use mile explain situation lead believe flight mile transfer mile deaf ear german office absolutely unhelpful uk customer service unhelpful manager able open flight mile repeat possible pay flight seat seat available gold status end british airways absolutely responsibility cause problem solution mile pay trip miami service customer company business time wait 45 minute answer hold 2 day wait talk british airway 2 hour day line 45 minute time tell lady agent hang phone long phone customer customer help	help	unk	Family Leisure	Business Class	Dusseldorf (DUS) to Miami (MIA)	January 2024	-0.884	(0.055, 0.909, 0.036)	-1.000
5	“uncomfortable seat and disgusting food”	Paid for business class travelling Cairo to London Heathrow but all I got was an economy seat. Only difference from economy is middle seat was vacant. Couldn't recline, no entertainment for the 5hr+ flight, uncomfortable seat and disgusting food. Put in a formal complaint 3 days ago and had no reply. BA's account on X is hacked. Got approached by scammers after posting there and even after flagging this to BA nothing done about it. Just disgusting. Avoid.	2024-01-16	Fady Magdy	United Kingdom	1	Type Of TravellerFamily Leisure\nSeat TypeBusiness Class\nRouteCairo to London Heathrow\nDate FlownJanuary 2024	n	pay business class travel cairo london heathrow economy seat difference economy middle seat vacant recline entertainment 5hr flight uncomfortable seat disgusting food formal complaint 3 day ago reply bas account x hack approach scammer post flag ba disgusting avoid	uncomfortable seat disgusting food	unk	Family Leisure	Business Class	Cairo to London Heathrow	January 2024	-0.972	(0.253, 0.721, 0.026)	-1.000
6	"Zero customer service"	The plane was extremely dirty with chocolate smudged all over mine and my children's seats. I had to wipe down all the seats. After we landed I immediately realized I left my camera with it's bag in the airplane overhead cabin. They would not let me back on the plane for security reasons so I went to The British Airways team on ground & they refused to contact cabin crew only until we threw up a massive fuss then the manager reluctantly agreed which by that point cabin crew had disembarked. Now it's been over 3 weeks with no sign of my camera so it is assumed stolen. I have complained to British Airways and all I get is an automated/generic response to keep checking with Lost Property. Zero customer service for their regular customers and this all could have been mitigated if they had been willing to help at the very beginning - very disappointed.	2024-01-15	A Karsin	Ireland	1	Type Of TravellerFamily Leisure\nSeat TypeEconomy Class\nRouteDublin to London Heathrow\nDate FlownJanuary 2024	n	plane extremely dirty chocolate smudge children seat wipe seat land immediately realize leave camera bag airplane overhead cabin let plane security reason british airways team ground refuse contact cabin crew throw massive fuss manager reluctantly agree point cabin crew disembark 3 week sign camera assume steal complain british airways automatedgeneric response check lose property zero customer service regular customer mitigate willing help beginning disappointed	zero customer service	unk	Family Leisure	Economy Class	Dublin to London Heathrow	January 2024	-0.908	(0.119, 0.839, 0.042)	-1.000
7	"baggage arrival nearly took 1.5 hours"	Overall journey wasn’t bad however at the end, the baggage arrival nearly took 1.5 hours (more than actual flight time). Baggage of other flights arriving after had been delivered whereas the baggage staff on airport had no clue and information as to why baggage of this flight hasn’t arrived. They raised their hands saying they can’t do anything further. Poor communication and no customer facing skills.	2024-01-12	Muhammad Yasin	United Kingdom	4	Type Of TravellerBusiness\nSeat TypeEconomy Class\nRouteGlasgow to London\nDate FlownJanuary 2024	n	overall journey bad end baggage arrival nearly 15 hour actual flight time baggage flight arrive deliver baggage staff airport clue information baggage flight arrive raise hand poor communication customer face skill	baggage arrival nearly 15 hour	unk	Business	Economy Class	Glasgow to London	January 2024	-0.875	(0.151, 0.849, 0.0)	-1.000
8	"Overall very satisfied"	Overall very satisfied. Ground staff member at YVR was extremely helpful & courteous. A350 was only a few months old, so seats were in good order & comfortable by the standards of a modern day Y class seat, although the very small washroom was already starting to look a bit shabby. Cabin crew very friendly & professional, & meal service carried out at reasonable time in the flight. Choice of 2 options for the main meal which was the same for both legs of my journey 1 month apart. Flight departed on time but unfortunately upon landing at LHR we were unable to deplane for quite some time due to a staffing issue at LHR which so not the fault of the airline, and we were given frequent updates on the situation from the flight manager & the flight deck.	2024-01-12	S Keane	United Kingdom	9	AircraftA350-1000\nType Of TravellerSolo Leisure\nSeat TypeEconomy Class\nRouteVancouver to London\nDate FlownJanuary 2024	y	overall satisfied ground staff member yvr extremely helpful courteous a350 month old seat good order comfortable standard modern day y class seat small washroom start look bit shabby cabin crew friendly professional meal service carry reasonable time flight choice 2 option main meal leg journey 1 month apart flight depart time unfortunately land lhr unable deplane time staffing issue lhr fault airline frequent update situation flight manager flight deck	overall satisfied	A350-1000	Solo Leisure	Economy Class	Vancouver to London	January 2024	0.872	(0.021, 0.874, 0.106)	0.750
9	"airline is a total disgrace"	As always when I fly BA it was a total shambles. I was booked Manchester - London - Madrid , BA first leg and Iberia 2nd, I try wherever possible to avoid BA, however the Manchester - London was late, however I ran for my IB flight and got to B gates just as boarding started, being Group 1 I went to board and the gate sounded an alarm, BA had removed me from the IB flight to a BA flight 3 hours later! As BA had reissued the ticket IB could not put me back on the flight, so 3 hours wasted because of BA’s total incompetence. This airline is a total disgrace, the crew were not nice, typical BA crew oh im so fabulous I don't need to be nice to paying passengers, club europe cramped and terrible food!	2024-01-09	Neil Jones	Spain	1	AircraftA320\nType Of TravellerBusiness\nSeat TypeBusiness Class\nRouteHeathrow to Madrid\nDate FlownOctober 2023	n	fly ba total shamble book manchester london madrid ba leg iberia 2nd try possible avoid ba manchester london late run ib flight b gate boarding start group 1 board gate sound alarm ba remove ib flight ba flight 3 hour later ba reissue ticket ib flight 3 hour waste bas total incompetence airline total disgrace crew nice typical ba crew oh m fabulous need nice pay passenger club europe cramp terrible food	airline total disgrace	A320	Business	Business Class	Heathrow to Madrid	October 2023	-0.918	(0.132, 0.823, 0.045)	-1.000

	title	reviews	published_dates	user_name	user_location	user_ratings	trip_details	would_recommed_to_others	reviews_lemm_spacy	title_lemm_spacy	aircraft	travel_type	seat	route	date_flown	vader_sentiment	vader_nnp	vader_upper_binned
1290	"additional payment to select seats"	Dubai to London Heathrow. It's bad that BA requests additional payment to select seats before the check-in. If flying solo it's not a big issue, but with any companion (in this case I was with my son of 10) it would have been an issue to be separate. This also means that if there are 3 or 4 flights, and a group of two (as in my case) the difference would be substantial, up to approx 1000$. Lucky enough at least on the return flight we were able to select the middle seats because the flight wasn't full. On board service was decent. Professional, courteous and friendly attendants. Toilets in the second half of the flight weren't too clean. Flat seats in business class are outdated but comfortable for a nice sleep. The aircraft did not have WiFi.	2018-04-03	14 reviewsN Salito	United Arab Emirates	7	AircraftBoeing 747\nType Of TravellerFamily Leisure\nSeat TypeBusiness Class\nRouteDubai to London Heathrow\nDate FlownMarch 2018	y	dubai london heathrow bad ba request additional payment select seat checkin fly solo big issue companion case son 10 issue separate mean 3 4 flight group case difference substantial approx 1000 lucky return flight able select middle seat flight board service decent professional courteous friendly attendant toilet second half flight clean flat seat business class outdated comfortable nice sleep aircraft wifi	additional payment select seat	Boeing 747	Family Leisure	Business Class	Dubai to London Heathrow	March 2018	0.962	(0.033, 0.823, 0.144)	0.750
1291	"outdated, unclean and uncomfortable"	London to Las Vegas. Disappointed at BA - flights were delayed (my partner took the same outbound flight on a different day and was delayed as well by 2-3hrs). Aircraft interior was outdated, unclean and uncomfortable seats with very small legroom space. No safety video which was surprising as most long haul flights include this. Food was tasteless and I did skip a meal in the end - during one of the snack times we weren't given the options by our FA but the guy sat next to us who was served by another FA was given different options. Inflight entertainment poor with very limited choices and monitors were very old. To ensure that I sit with my partner on the return flight, we paid to reserve our seats - not impressed by this especially when we realised that the legroom space for my partner was obstructed by a broke IFE box which was loosely fitted so the door kept opening taking his legroom space as well as exposing the cables in the box which if you knocked it down would affect his monitor. Learnt our lessons, next time we will not fly BA!	2018-04-03	T Leane	United Kingdom	2	Type Of TravellerCouple Leisure\nSeat TypeEconomy Class\nRouteLondon to Las Vegas \nDate FlownMarch 2018	n	london las vegas disappoint ba flight delay partner outbound flight different day delay 23hrs aircraft interior outdate unclean uncomfortable seat small legroom space safety video surprising long haul flight include food tasteless skip meal end snack time option fa guy sit serve fa different option inflight entertainment poor limited choice monitor old ensure sit partner return flight pay reserve seat impress especially realise legroom space partner obstruct broke ife box loosely fit door open legroom space expose cable box knock affect monitor learn lesson time fly ba	outdate unclean uncomfortable	unk	Couple Leisure	Economy Class	London to Las Vegas	March 2018	-0.877	(0.116, 0.823, 0.061)	-1.000
1292	"the utmost courtesy and assistance"	Tampa to Gatwick. I am a disabled traveller with considerable mobility issues. As I usually travel alone I can find it extremely difficult. However, from the moment I arrived at the check in desk in Tampa I was met with the utmost courtesy and assistance. From the check in clerk at business class waving me forward to use his terminal things just went from excellent to exceptional. I was helped to put my suitcase onto the conveyor scale and assisted with every step of the way until the aircraft door. Every person was polite, helpful and went out of their way to make my journey as pleasant as possible. I witnessed such kindness and this is what I have come to expect and value from British Airways. Having used other airlines in the past - I am converted - I will not use any other airline in future.	2018-04-03	E Penton	United Kingdom	10	Type Of TravellerSolo Leisure\nSeat TypeEconomy Class\nRouteTampa to Gatwick\nDate FlownMarch 2018	y	tampa gatwick disabled traveller considerable mobility issue usually travel find extremely difficult moment arrive check desk tampa meet utmost courtesy assistance check clerk business class wave forward use terminal thing excellent exceptional help suitcase conveyor scale assist step way aircraft door person polite helpful way journey pleasant possible witness kindness come expect value british airway having airline past convert use airline future	utmost courtesy assistance	unk	Solo Leisure	Economy Class	Tampa to Gatwick	March 2018	0.917	(0.029, 0.862, 0.109)	0.750
1293	"pleasantly surprised to be upgraded"	Heathrow to Keflavik. I had booked economy, was pleasantly surprised to be upgraded when I checked in online. Priority boarding worked well and even though the flight was full there was no overhead locker range. The inflight meal was prawns was generous along with a good selection of wine. Off loading was straightforward. The return flight was on time, the pre booked emergency seat had more leg room the premium seat. M&S food service was OK. The cabin crews were slow at taking payment. Overall similar experience to an easyjet flight.	2018-04-02	3 reviewsAlly Wharton	United Kingdom	7	AircraftA320\nType Of TravellerBusiness\nSeat TypeEconomy Class\nRouteHeathrow to Keflavik\nDate FlownMarch 2018	y	heathrow keflavik book economy pleasantly surprised upgrade check online priority boarding work flight overhead locker range inflight meal prawn generous good selection wine loading straightforward return flight time pre book emergency seat leg room premium seat ms food service ok cabin crew slow payment overall similar experience easyjet flight	pleasantly surprise upgrade	A320	Business	Economy Class	Heathrow to Keflavik	March 2018	0.818	(0.047, 0.823, 0.13)	0.750
1294	"crew very friendly and professional"	London to Muscat first class. First time trying out first class on BA. Check-in was fairly quick and efficient, didn't have much luggage, but the first wing did not feel very exclusive. I had selected window seat in advance and this was confirmed and still intact as I got printed boarding pass. Concorde room was nice, well designed but quite crowded in some places. Had to ask for a champagne two times out in the terrace, before it got served a good 20 minutes later. Checkout out the cabana for an hour, which was not very appealing at all, and managed to miss the first 5 min of the 15min treatment I booked for the Spa. Onboard was informed there was a problem with the Seat I had selected, and was issued a new aisle seat, which was disappointing. Upon entering the first class cabin, I had a quick look at the seat, and it was not immediately apparent, there was something wrong. I asked a crew to check and they came back to confirm that I will indeed not be able to sit there, but there was no explanation of what was wrong given. I did not want to waste any time to settle in, the crew looking after me introduced himself and served me champagne and warm nuts as well as offering some magazines to read. Seat was comfortable and spacious enough and seemed fairly private, with a small wardrobe to hang jacket. The TV screen seemed quite large and high quality. Unfortunately the seat controls were not super responsive, and neither was the remote for the TV. Soon after take off, I was informed I could eat when I like. Arabic starter was great. Had pre-selected main meal online. Meal was of good quality and cooked well. Had a dessert and the mixed cheese plate (not as good as other cheese I've had in some Business class). Surprisingly the entertainment system had a rather limited selection, I imagine on two ultra-long flights in the same month, one might run out of anything of interest to watch. After finishing the one film I decided to watch, I decided to try get some sleep. Crew made the bedding while I tried to put on the pyjamas in the tiny first class bathroom. Bedding was of good quality and comfortable enough. I missed breakfast, as I was still rather full from the dinner and pre-dinner at the lounge. Overall, I was reasonably happy with the flight and the product. The crew were very friendly and professional. Given this was first class, have to admit there was no wow factor, either with the soft product or ground experience. I managed to book flights for a good price during a promo, otherwise it would personally not be worth the price tag for a fairly short flight.	2018-04-01	F Hamzil	United Kingdom	7	AircraftBoeing 787-9\nType Of TravellerSolo Leisure\nSeat TypeFirst Class\nRouteLondon to Muscat\nDate FlownMarch 2018	y	london muscat class time try class ba checkin fairly quick efficient luggage wing feel exclusive select window seat advance confirm intact print boarding pass concorde room nice design crowded place ask champagne time terrace serve good 20 minute later checkout cabana hour appealing manage miss 5 min 15min treatment book spa onboard inform problem seat select issue new aisle seat disappointing enter class cabin quick look seat immediately apparent wrong ask crew check come confirm able sit explanation wrong want waste time settle crew look introduce serve champagne warm nut offer magazine read seat comfortable spacious fairly private small wardrobe hang jacket tv screen large high quality unfortunately seat control super responsive remote tv soon inform eat like arabic starter great preselecte main meal online meal good quality cook dessert mixed cheese plate good cheese ve business class surprisingly entertainment system limited selection imagine ultralong flight month run interest watch finish film decide watch decide try sleep crew bedding try pyjama tiny class bathroom bedding good quality comfortable miss breakfast dinner predinner lounge overall reasonably happy flight product crew friendly professional class admit wow factor soft product ground experience manage book flight good price promo personally worth price tag fairly short flight	crew friendly professional	Boeing 787-9	Solo Leisure	First Class	London to Muscat	March 2018	0.986	(0.091, 0.765, 0.144)	0.750
1295	"entertainment was not working"	My family and I travelled from Cape Town to London on the 10th March 2018. We have a 1 year old and a 4 year old. Once seated, we realised that our entertainment system was not working. The cabin light for all seats that we had booked were not working either. There was minimal effort from the cabin team to try and resolve this. As it was a night flight, my wife and I had to see to our 1 year old in the dark. Any help we needed required us to walk to the galley to receive any assistance. As BAs safety demonstration prior to take off is on video, we didn't receive this. The flight was the worst airline experience we've had. I doubt I'll ever fly with BA again.	2018-04-01	Muhammad Kajee	United Kingdom	1	Type Of TravellerFamily Leisure\nSeat TypeEconomy Class\nRouteCape Town to London\nDate FlownMarch 2018	n	family travel cape town london 10th march 2018 1 year old 4 year old seat realise entertainment system work cabin light seat book work minimal effort cabin team try resolve night flight wife 1 year old dark help need require walk galley receive assistance bas safety demonstration prior video receive flight bad airline experience ve doubt ill fly ba	entertainment work	unk	Family Leisure	Economy Class	Cape Town to London	March 2018	0.572	(0.046, 0.869, 0.085)	0.500
1296	"staff try so very hard to please"	Gatwick to Madeira. The flight left on time and arrived early, slept as early morning flight. The plane was not very clean, grubby tray between seats and ingrained dirt in the spokes of the seats. The staff were pleasant. Breakfast was offered and my children felt it was adequate. The return was poorly organised, no use of fast track security for business class passengers. Long queue for boarding and a grubby plane. Really no point in paying for business class. The staff try so very hard to please the passengers but nearly 4 hours and no entertainment, dog-eared magazines. Quickly disembarked and swiftly through immigration.	2018-03-30	P Dean	United Kingdom	4	AircraftA320\nType Of TravellerFamily Leisure\nSeat TypeBusiness Class\nRouteGatwick to Madeira\nDate FlownMarch 2018	n	gatwick madeira flight leave time arrive early sleep early morning flight plane clean grubby tray seat ingrain dirt spoke seat staff pleasant breakfast offer child feel adequate return poorly organise use fast track security business class passenger long queue boarding grubby plane point pay business class staff try hard passenger nearly 4 hour entertainment dogeare magazine quickly disembark swiftly immigration	staff try hard	A320	Family Leisure	Business Class	Gatwick to Madeira	March 2018	-0.099	(0.098, 0.816, 0.086)	-0.250
1297	"extremely unprofessional"	London to Casablanca. Their customer service quality in Heathrow Terminal 3 is very patchy. For background, my initial flight was with TAP Portugal which got cancelled, then rebooked to BA. My second flight had further issue, and instead of requesting TAP to rebook me, BA took the liberty of rebooking a 3rd flight for me - which turned out to be overbooked. This then caused me having to liaise with both TAP and BA to rebook my 4th flight - I was tossed around by both customer care telling me it's not their problem. TAP can no longer rebook me on another flight as they have lost the right to alter the ticket as soon as BA rebooked me on the 3rd flight. I was initially served by a very helpful staff who attends to my rebooking issue - the last flight I was rebooked was overbooked. However, later on I was passed on to a couple of rude staff that were reluctant to serve me as it was 15 minutes past their end of shift. They were also talking about me in front of me and accused me of taking advantage of BA. This is very rude and extremely unprofessional. I've never had this treatment during my 10+ years of flying with various airlines, both top rated and low cost carrier.	2018-03-30	E Christie	United Kingdom	2	Type Of TravellerSolo Leisure\nSeat TypeEconomy Class\nRouteLondon to Casablanca\nDate FlownMarch 2018	n	london casablanca customer service quality heathrow terminal 3 patchy background initial flight tap portugal cancel rebooke ba second flight issue instead request tap rebook ba liberty rebooke 3rd flight turn overbooke cause liaise tap ba rebook 4th flight toss customer care tell problem tap long rebook flight lose right alter ticket soon ba rebooke 3rd flight initially serve helpful staff attend rebooking issue flight rebooke overbooke later pass couple rude staff reluctant serve 15 minute past end shift talk accuse advantage ba rude extremely unprofessional ve treatment 10 year fly airline rate low cost carrier	extremely unprofessional	unk	Solo Leisure	Economy Class	London to Casablanca	March 2018	-0.713	(0.092, 0.843, 0.064)	-0.750
1298	"manager is very professional"	British Airways flight manager is very professional. I travelled on BA985 from Berlin to Hong Kong via London on 19 Feb. Due to the snowy weather, my flight leaving Berlin to London was delayed, in which I was worried about missing my connecting flight from London to Hong Kong. During the flight, the manager came to me several times, explained to me the reason of flight delay, informed me about the connecting flight arrangements. Her information was very clear, trusted she has been working closely with airport ground on this. Very much appreciated for their service.	2018-03-28	N Wang	Hong Kong	8	Type Of TravellerSolo Leisure\nSeat TypeEconomy Class\nRouteBerlin to Hong Kong via London\nDate FlownFebruary 2018	y	british airways flight manager professional travel ba985 berlin hong kong london 19 feb snowy weather flight leave berlin london delay worried miss connect flight london hong kong flight manager come time explain reason flight delay inform connect flight arrangement information clear trust work closely airport ground appreciate service	manager professional	unk	Solo Leisure	Economy Class	Berlin to Hong Kong via London	February 2018	0.502	(0.08, 0.828, 0.092)	0.500
1299	"regret choosing BA"	Hyderabad to Brussels via London. Didn't expect this from British Airways. For me quality hit the rock bottom. Especially the unclean flight. I would have preferred the aircraft from Brussels to London and vice versa for the long haul travel. Maybe my expectations was too high but considering the price I paid for ticket I think it's not worth it. Other airline which I used to travel had the same price and if I compare the services of that ariline I regret choosing British Airways.	2018-03-28	Aditya Nagaram	Belgium	2	Type Of TravellerSolo Leisure\nSeat TypeEconomy Class\nRouteHyderabad to Brussels via London\nDate FlownMarch 2018	n	hyderabad brussels london expect british airways quality hit rock especially unclean flight prefer aircraft brussels london vice versa long haul travel maybe expectation high consider price pay ticket think worth airline travel price compare service ariline regret choose british airways	regret choose ba	unk	Solo Leisure	Economy Class	Hyderabad to Brussels via London	March 2018	-0.691	(0.064, 0.936, 0.0)	-0.750

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Final Punctuation

Control

Currency Symbol

Dash Punctuation

Initial Punctuation

Other Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Punctuation

None

Currency Symbols

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Dash Punctuation

Currency Symbol

Math Symbol

Space Separator

Final Punctuation

Close Punctuation

Open Punctuation

Initial Punctuation

Control

Line Separator

Other Number

Modifier Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Punctuation

None

Currency Symbols

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script